package com.jeecg.o2o.buser.controller;

import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.ConstraintViolation;
import javax.validation.Validator;

import org.apache.commons.lang3.StringUtils;
import org.apache.log4j.Logger;
import org.jeecgframework.core.beanvalidator.BeanValidators;
import org.jeecgframework.core.common.controller.BaseController;
import org.jeecgframework.core.common.exception.BusinessException;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.AjaxJson;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.ExceptionUtil;
import org.jeecgframework.core.util.MD5Util;
import org.jeecgframework.core.util.MyBeanUtils;
import org.jeecgframework.core.util.ResourceUtil;
import org.jeecgframework.jwt.service.TokenManager;
import org.jeecgframework.jwt.util.ResponseMessage;
import org.jeecgframework.jwt.util.Result;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.ResponseStatus;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.util.UriComponentsBuilder;

import com.alibaba.fastjson.JSON;
import com.jeecg.o2o.buser.entity.BuserEntity;
import com.jeecg.o2o.buser.service.BuserServiceI;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import net.sf.json.JSONObject;

/**
 * @Title: Controller
 * @Description: 商户用户表
 * @author onlineGenerator
 * @date 2019-02-09 11:44:38
 * @version V1.0
 *
 */
@Api(value = "Buser", description = "商户用户表", tags = "buserController")
@Controller
@RequestMapping("/buserController")
public class BuserController extends BaseController {
	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(BuserController.class);

	@Autowired
	private BuserServiceI buserService;
	@Autowired
	private SystemService systemService;
	@Autowired
	private Validator validator;
	@Autowired
	private TokenManager tokenManager;

	/**
	 * 商户用户表列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "list")
	public ModelAndView list(HttpServletRequest request) {
		return new ModelAndView("com/jeecg/o2o.buser/buserList");
	}

	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */
	@RequestMapping(params = "datagrid")
	public void datagrid(BuserEntity buser, HttpServletRequest request, HttpServletResponse response,
			DataGrid dataGrid) {
		CriteriaQuery cq = new CriteriaQuery(BuserEntity.class, dataGrid);
		// 查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, buser, request.getParameterMap());
		cq.add();

		// 获取商家标识
		String shopuid = request.getHeader("shopuid");
		if (shopuid != null && !shopuid.trim().equals("")) {
			// 商家请求操作
			int total = buserService.queryCountForJdbcParam(BuserEntity.class, shopuid, buser);
			List<BuserEntity> litst = buserService.queryPreEntrylistForJdbcParam(BuserEntity.class,
					shopuid, buser, dataGrid.getPage(), dataGrid.getRows());
			dataGrid.setResults(litst);
			dataGrid.setTotal(total);
			// this.buserService.getDataGridReturn(cq, true);
		} else {
			// 平台操作
			this.buserService.getDataGridReturn(cq, true);

		}

		TagUtil.datagrid(response, dataGrid);
	}

	/**
	 * 删除商户用户表
	 * 
	 * @return
	 */
	@RequestMapping(params = "doDel")
	@ResponseBody
	public AjaxJson doDel(BuserEntity buser, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();

		message = "商户用户表删除成功";
		try {
			// 获取商家标识
			String shopuid = request.getHeader("shopuid");
			if (shopuid != null && !shopuid.trim().equals("")) {
				// 商家删除
				String stringArray[] = new String[1];
				stringArray[0] = String.valueOf(buser.getId());
				buserService.deletebyBatch(BuserEntity.class, shopuid, stringArray);
			} else {
				// 平台删除
				buser = systemService.getEntity(BuserEntity.class, buser.getId());
				buserService.delete(buser);
			}

			systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			message = "商户用户表删除失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 批量删除商户用户表
	 * 
	 * @return
	 */
	@RequestMapping(params = "doBatchDel")
	@ResponseBody
	public AjaxJson doBatchDel(String ids, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "商户用户表删除成功";
		try {
			// 获取商家标识
			String shopuid = request.getHeader("shopuid");
			if (shopuid != null && !shopuid.trim().equals("")) {
				buserService.deletebyBatch(BuserEntity.class, shopuid, ids.split(","));
			} else {
				for (String id : ids.split(",")) {
					BuserEntity buser = systemService.getEntity(BuserEntity.class, Integer.parseInt(id));
					buserService.delete(buser);
					systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
			message = "商户用户表删除失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 添加商户用户表
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(params = "doAdd")
	@ResponseBody
	public AjaxJson doAdd(BuserEntity buser, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "商户用户表添加成功";
		try {
			buser.setPassword(MD5Util.MD5Encode(buser.getPassword(), "UTF-8"));
			// 获取商家标识
			String shopuid = request.getHeader("shopuid");
			if (shopuid != null && !shopuid.trim().equals("")) {
				buserService.saveorupdatePreEntry(buser, shopuid);
			} else {
				buserService.save(buser);
			}

			systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			message = "商户用户表添加失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 更新商户用户表
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(params = "doUpdate")
	@ResponseBody
	public AjaxJson doUpdate(BuserEntity buser, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "商户用户表更新成功";
		try {

			// 获取商家标识
			String shopuid = request.getHeader("shopuid");
			if (shopuid != null && !shopuid.trim().equals("")) {
				buserService.saveorupdatePreEntry(buser, shopuid);
			} else {

				BuserEntity t = buserService.get(BuserEntity.class, buser.getId());
				MyBeanUtils.copyBeanNotNull2Bean(buser, t);
				buserService.saveOrUpdate(t);
			}

			systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			message = "商户用户表更新失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 导入功能跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "upload")
	public ModelAndView upload(HttpServletRequest req) {
		req.setAttribute("controller_name", "buserController");
		return new ModelAndView("common/upload/pub_excel_upload");
	}

	/**
	 * 导出excel
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXls")
	public String exportXls(BuserEntity buser, HttpServletRequest request, HttpServletResponse response,
			DataGrid dataGrid, ModelMap modelMap) {
		response.setContentType("application/msexcel;charset=utf-8");
		CriteriaQuery cq = new CriteriaQuery(BuserEntity.class, dataGrid);
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, buser, request.getParameterMap());
		List<BuserEntity> busers = null;
		// 获取商家标识
		String shopuid = request.getHeader("shopuid");
		if (shopuid != null && !shopuid.trim().equals("")) {
			busers = buserService.queryPreEntrylistForJdbcParam(BuserEntity.class, shopuid, buser,
					dataGrid.getPage(), dataGrid.getRows());
			modelMap.put(NormalExcelConstants.PARAMS, new ExportParams("商户用户表列表", "导出人:", "导出信息"));
		} else {
			busers = this.buserService.getListByCriteriaQuery(cq, false);
			modelMap.put(NormalExcelConstants.PARAMS,
					new ExportParams("商户用户表列表", "导出人:" + ResourceUtil.getSessionUser().getRealName(), "导出信息"));
		}

		modelMap.put(NormalExcelConstants.FILE_NAME, "商户用户表");
		modelMap.put(NormalExcelConstants.CLASS, BuserEntity.class);

		modelMap.put(NormalExcelConstants.DATA_LIST, busers);
		return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}

	/**
	 * 导出excel 使模板
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXlsByT")
	public String exportXlsByT(BuserEntity buser, HttpServletRequest request, HttpServletResponse response,
			DataGrid dataGrid, ModelMap modelMap) {
		modelMap.put(NormalExcelConstants.FILE_NAME, "商户用户表");
		modelMap.put(NormalExcelConstants.CLASS, BuserEntity.class);
		modelMap.put(NormalExcelConstants.PARAMS,
				new ExportParams("商户用户表列表", "导出人:" + ResourceUtil.getSessionUser().getRealName(), "导出信息"));
		modelMap.put(NormalExcelConstants.DATA_LIST, new ArrayList());
		return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}

	@SuppressWarnings("unchecked")
	@RequestMapping(params = "importExcel", method = RequestMethod.POST)
	@ResponseBody
	public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
		AjaxJson j = new AjaxJson();

		MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
		for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
			MultipartFile file = entity.getValue();// 获取上传文件对象
			ImportParams params = new ImportParams();
			params.setTitleRows(2);
			params.setHeadRows(1);
			params.setNeedSave(true);
			try {
				List<BuserEntity> listBuserEntitys = ExcelImportUtil.importExcel(file.getInputStream(),
						BuserEntity.class, params);
				for (BuserEntity buser : listBuserEntitys) {
					buserService.save(buser);
				}
				j.setMsg("文件导入成功！");
			} catch (Exception e) {
				j.setMsg("文件导入失败！");
				logger.error(ExceptionUtil.getExceptionMessage(e));
			} finally {
				try {
					file.getInputStream().close();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
		return j;
	}

	@RequestMapping(method = RequestMethod.GET)
	@ResponseBody
	@ApiOperation(value = "商户用户表列表信息", produces = "application/json", httpMethod = "GET")
	public ResponseMessage<List<BuserEntity>> list() {
		List<BuserEntity> listBusers = buserService.getList(BuserEntity.class);
		return Result.success(listBusers);
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.GET)
	@ResponseBody
	@ApiOperation(value = "根据ID获取商户用户表信息", notes = "根据ID获取商户用户表信息", httpMethod = "GET", produces = "application/json")
	public ResponseMessage<?> get(@ApiParam(required = true, name = "id", value = "ID") @PathVariable("id") String id) {
		BuserEntity task = buserService.get(BuserEntity.class, id);
		if (task == null) {
			return Result.error("根据ID获取商户用户表信息为空");
		}
		return Result.success(task);
	}

	@RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE)
	@ResponseBody
	@ApiOperation(value = "创建商户用户表")
	public ResponseMessage<?> create(@ApiParam(name = "商户用户表对象") @RequestBody BuserEntity buser,
			UriComponentsBuilder uriBuilder) {
		// 调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<BuserEntity>> failures = validator.validate(buser);
		if (!failures.isEmpty()) {
			return Result.error(JSON.toJSONString(BeanValidators.extractPropertyAndMessage(failures)));
		}

		// 保存
		try {
			buserService.save(buser);
		} catch (Exception e) {
			e.printStackTrace();
			return Result.error("商户用户表信息保存失败");
		}
		return Result.success(buser);
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.PUT, consumes = MediaType.APPLICATION_JSON_VALUE)
	@ResponseBody
	@ApiOperation(value = "更新商户用户表", notes = "更新商户用户表")
	public ResponseMessage<?> update(@ApiParam(name = "商户用户表对象") @RequestBody BuserEntity buser) {
		// 调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<BuserEntity>> failures = validator.validate(buser);
		if (!failures.isEmpty()) {
			return Result.error(JSON.toJSONString(BeanValidators.extractPropertyAndMessage(failures)));
		}

		// 保存
		try {
			buserService.saveOrUpdate(buser);
		} catch (Exception e) {
			e.printStackTrace();
			return Result.error("更新商户用户表信息失败");
		}

		// 按Restful约定，返回204状态码, 无内容. 也可以返回200状态码.
		return Result.success("更新商户用户表信息成功");
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
	@ResponseStatus(HttpStatus.NO_CONTENT)
	@ApiOperation(value = "删除商户用户表")
	public ResponseMessage<?> delete(
			@ApiParam(name = "id", value = "ID", required = true) @PathVariable("id") String id) {
		logger.info("delete[{}]" + id);
		// 验证
		if (StringUtils.isEmpty(id)) {
			return Result.error("ID不能为空");
		}
		try {
			buserService.deleteEntityById(BuserEntity.class, id);
		} catch (Exception e) {
			e.printStackTrace();
			return Result.error("商户用户表删除失败");
		}

		return Result.success();
	}

	@RequestMapping(value = "/login", method = RequestMethod.POST)
	@ResponseBody
	@ApiOperation(value = "商家后台用户登录", produces = "application/json;charset=UTF-8", httpMethod = "POST")
	public ResponseMessage<BuserEntity> login(@ApiParam(name = "商户实体信息") @RequestBody BuserEntity BuserEntity,
			HttpServletRequest request, HttpServletResponse response) throws Exception {

		// 创建商户需要同步创建所有的表，新增一个管理员数据进去buser表
		String shopuid = request.getHeader("shopuid");
		List<BuserEntity> litst = (List<BuserEntity>) buserService.queryPreEntrylist(BuserEntity.getClass(), shopuid,
				" username=? and password=? ", BuserEntity.getUsername(),
				MD5Util.MD5Encode(BuserEntity.getPassword(), "UTF-8"));

		if (litst != null && litst.size() > 0) {
			// 验证通过
			// 1、根据userid和商家前缀生成token返回
			// 2、保存token到redis
			BuserEntity = litst.get(0);
			String token = tokenManager.createToken(BuserEntity, shopuid);
			BuserEntity.setToken(token);
			return Result.success(BuserEntity);
		} else {
			// 验证不通过
			BuserEntity.setMessage("登录账号或者密码不正确");
			return Result.success(BuserEntity);
		}

	}

	@RequestMapping(value = "/signout", method = RequestMethod.POST)
	@ResponseBody
	@ApiOperation(value = "商家后台用户退出", produces = "application/json;charset=UTF-8", httpMethod = "POST")
	public ResponseMessage<BuserEntity> signout(BuserEntity BuserEntity, HttpServletRequest request,
			HttpServletResponse response, @RequestBody JSONObject id) throws Exception {

		Map<String, Object> c = new HashMap<String, Object>();
		// 创建商户需要同步创建所有的表，新增一个管理员数据进去buser表
		String shopuid = request.getHeader("shopuid");
		String userid = id.get("id").toString();
		// String userid = request.getAttribute("id").getParameter("id");
		tokenManager.deleteToken(shopuid + userid);
		BuserEntity.setStatus("1");
		return Result.success(BuserEntity);

	}
}
